alter table jms_dm.dm_truck_wabill_flow_count_ht set tblproperties ('external.table.purge'='true');
DROP TABLE jms_dm.dm_truck_wabill_flow_count_ht;
CREATE EXTERNAL TABLE jms_dm.dm_truck_wabill_flow_count_ht(
  `shipment_no` string COMMENT '任务号',
    `previous_network_code` string COMMENT '上一站点',
    `previous_network_name` string COMMENT '上一站点名称',
    `current_center_code` string COMMENT '到达中心',
    `current_center_name` string COMMENT '到达中心名称',
    `next_network_code` string COMMENT '下一站点',
    `next_network_name` string COMMENT '下一站点名称',
    `waybill_cnt` int COMMENT '总票数',
    `same_next_cnt` int COMMENT '相同站点票数',
    `rk` int COMMENT '排序')
  COMMENT '车内件流向top3'
PARTITIONED BY (
  `dt` string COMMENT '规划离开时间 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_truck_wabill_flow_count_ht'
TBLPROPERTIES (
          'discover.partitions' = 'false',
          'parquet.column.index.access' = 'true'
          );
